package cells.merge;
import java.util.ArrayList;
import com.aspose.cells.CellArea;
import com.aspose.cells.Workbook;
import com.aspose.cells.Worksheet;
public class AsposeDetectMergeCells
{
public static void main(String[] args) throws Exception
{
//Instantiate a new Workbook
Workbook workbook = new Workbook("data/MergeInput.xls");
//Get a worksheet in the workbook
Worksheet worksheet = workbook.getWorksheets().get(0);
//Clear its contents
worksheet.getCells().clearContents(0,0,worksheet.getCells().getMaxDataRow(),worksheet.getCells().getMaxDataColumn());
//Create an arraylist object
//Get the merged cells list to put it into the arraylist object
ArrayList<CellArea> al = worksheet.getCells().getMergedCells();
//Define cellarea
CellArea ca;
//Define some variables
int frow, fcol, erow, ecol;
// Print Message
System.out.println("Merged Areas: \n"+ al.toString());
//Loop through the arraylist and get each cellarea to unmerge it
for(int i = al.size()-1 ; i > -1; i--)
{
ca = new CellArea();
ca = (CellArea)al.get(i);
frow = ca.StartRow;
fcol = ca.StartColumn;
erow = ca.EndRow;
ecol = ca.EndColumn;
System.out.println((i+1) + ". [" + fcol +"," + frow +"] " + "[" + ecol +"," + erow +"]");
worksheet.getCells().unMerge(frow, fcol, erow, ecol);
}
//Save the excel file
workbook.save("data/AsposeMergeOutput.xls");
// Print Message
System.out.println("Detect Merge Cells successful.");
}
}